Spotlight report for motif SNPs in (pos/neg method first_try)

1 Load data

df <- read.table('../../../output/first_try/report/summary_table.txt', header = T)
df$rownum <- 1 : nrow(df)

df.sub <- df[df$motif_qval < 0.05 & df$r2 > 0.5, ]
df.sub$strand <- as.character(df.sub$strand)
df.sub$strand[df.sub$strand == '-'] <- 'negative'
df.sub$strand[df.sub$strand == '+'] <- 'positive'
row.names(df.sub) <- NULL
motif_logo_prefix <- '../../../output/first_try/report/motif_logo/'
mash_plot_prefix <- '../../../output/first_try/report/mash_plot//mash__idx'

for(i in 1 : nrow(df.sub)) {
    motif_logo <- paste0(motif_logo_prefix, df.sub$dbname[i], '__', df.sub$motif_id[i], '.png')
    mash_plot <- paste0(mash_plot_prefix, df.sub$idx[i], '.png')
    cat('#', as.character(df.sub$gene_name[i]), as.character(df$motif_id[i]), '\n', '\n')
    df.show <- df.sub[, - which(colnames(df.sub) %in% c('idx', 'motif_from', 'motif_matched_sequence', 'motif_qval', 'dbname', 'rownum'))]
    pander(df.show[i, ])
    img1 <- rasterGrob(as.raster(readPNG(motif_logo)), interpolate = FALSE)
    img2 <- rasterGrob(as.raster(readPNG(mash_plot)), interpolate = FALSE)
    grid.arrange(img1, img2, ncol = 2)
    # cat(motif_logo, mash_plot, '\n')
    # df.sub[i, ] %>% kable(format = "html", col.names = colnames(df.sub)) %>%
    #   kable_styling() %>%
    #   kableExtra::scroll_box(width = "100%", height = "200px")
    cat('\n', '\n')
}

2 TMA7 COT2_HUMAN.H11MO.1.A

gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
TMA7	ENSG00000232112	3_48479207_C_T_b37	3_48481647_G_A_b37	0.9998	SP1_HUMAN.H11MO.1.A	NA	2	14	positive	Heart_Atrial_Appendage

3 TMA7 COT2_HUMAN.H11MO.1.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
2	TMA7	ENSG00000232112	3_48479207_C_T_b37	3_48481647_G_A_b37	0.9998	SP1_HUMAN.H11MO.0.A	NA	2	22	positive	Heart_Atrial_Appendage

4 PDIA2 MA0512.2

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
3	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	SP1_HUMAN.H11MO.1.A	NA	8	14	negative	Heart_Atrial_Appendage

5 PDIA2 MA0677.1

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
4	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	SP1_HUMAN.H11MO.0.A	NA	8	22	negative	Heart_Atrial_Appendage

6 PDIA2 SP1_HUMAN.H11MO.1.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
5	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	SP1_HUMAN.H11MO.0.A	NA	15	22	negative	Heart_Atrial_Appendage

7 PDIA2 SP1_HUMAN.H11MO.1.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
6	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	SP1_HUMAN.H11MO.0.A	NA	2	22	negative	Heart_Atrial_Appendage

8 PDIA2 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
7	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	SP1_HUMAN.H11MO.0.A	NA	17	22	negative	Heart_Atrial_Appendage

9 PDIA2 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
8	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	SP1_HUMAN.H11MO.0.A	NA	13	22	negative	Heart_Atrial_Appendage

10 PRKCA MEF2A_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
9	PRKCA	ENSG00000154229	17_64315205_A_C_b37	17_64298682_G_A_b37	0.8253	SP1_HUMAN.H11MO.0.A	NA	21	22	positive	Heart_Atrial_Appendage

11 PRKCA SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
10	PRKCA	ENSG00000154229	17_64315205_A_C_b37	17_64298682_G_A_b37	0.8253	SP1_HUMAN.H11MO.0.A	NA	16	22	negative	Heart_Atrial_Appendage

12 RAB40B SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
11	RAB40B	ENSG00000141542	17_80645286_C_G_b37	17_80656616_T_G_b37	0.5002	SP1_HUMAN.H11MO.0.A	NA	22	22	negative	Heart_Atrial_Appendage

13 RAB40B SP1_HUMAN.H11MO.1.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
12	RAB40B	ENSG00000141542	17_80645286_C_G_b37	17_80656616_T_G_b37	0.5002	SP1_HUMAN.H11MO.0.A	NA	12	22	negative	Heart_Atrial_Appendage

14 RAB40B SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
13	RAB40B	ENSG00000141542	17_80645286_C_G_b37	17_80656616_T_G_b37	0.5002	SP1_HUMAN.H11MO.0.A	NA	17	22	negative	Heart_Atrial_Appendage

15 RAB40B SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
14	RAB40B	ENSG00000141542	17_80645286_C_G_b37	17_80656616_T_G_b37	0.5002	SP1_HUMAN.H11MO.1.A	NA	12	14	negative	Heart_Atrial_Appendage

16 SIPA1L3 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
15	SIPA1L3	ENSG00000105738	19_38670754_C_T_b37	19_38664097_C_T_b37	0.9999	SP1_HUMAN.H11MO.0.A	NA	14	22	negative	Heart_Atrial_Appendage

17 SIPA1L3 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
16	SIPA1L3	ENSG00000105738	19_38670754_C_T_b37	19_38664097_C_T_b37	0.9999	SP1_HUMAN.H11MO.0.A	NA	18	22	positive	Heart_Atrial_Appendage

18 CCDC157 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
17	CCDC157	ENSG00000187860	22_30765502_G_A_b37	22_30752942_C_A_b37	0.9667	SP1_HUMAN.H11MO.0.A	NA	8	22	negative	Heart_Atrial_Appendage

19 CCDC157 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
18	CCDC157	ENSG00000187860	22_30765502_G_A_b37	22_30752942_C_A_b37	0.9667	SP1_HUMAN.H11MO.0.A	NA	2	22	negative	Heart_Atrial_Appendage

20 TMA7 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
19	TMA7	ENSG00000232112	3_48479207_C_T_b37	3_48481647_G_A_b37	0.9998	MA0079.3	SP1	11	11	negative	Heart_Atrial_Appendage

21 PDIA2 SP1_HUMAN.H11MO.1.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
20	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	MA0079.3	SP1	5	11	positive	Heart_Atrial_Appendage

22 WDR59 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
21	WDR59	ENSG00000103091	16_74937232_T_A_b37	16_74938857_G_A_b37	0.5144	MA0512.2	Rxra	13	14	negative	Heart_Left_Ventricle

23 TMA7 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
22	TMA7	ENSG00000232112	3_48479207_C_T_b37	3_48481647_G_A_b37	0.9998	SP1_HUMAN.H11MO.1.A	NA	2	14	positive	Heart_Left_Ventricle

24 TMA7 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
23	TMA7	ENSG00000232112	3_48479207_C_T_b37	3_48481647_G_A_b37	0.9998	SP1_HUMAN.H11MO.0.A	NA	2	22	positive	Heart_Left_Ventricle

25 PDIA2 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
24	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	SP1_HUMAN.H11MO.1.A	NA	8	14	negative	Heart_Left_Ventricle

26 PDIA2 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
25	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	SP1_HUMAN.H11MO.0.A	NA	8	22	negative	Heart_Left_Ventricle

27 PDIA2 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
26	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	SP1_HUMAN.H11MO.0.A	NA	15	22	negative	Heart_Left_Ventricle

28 PDIA2 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
27	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	SP1_HUMAN.H11MO.0.A	NA	2	22	negative	Heart_Left_Ventricle

29 PDIA2 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
28	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	SP1_HUMAN.H11MO.0.A	NA	17	22	negative	Heart_Left_Ventricle

30 PDIA2 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
29	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	SP1_HUMAN.H11MO.0.A	NA	13	22	negative	Heart_Left_Ventricle

31 PRKCA SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
30	PRKCA	ENSG00000154229	17_64315205_A_C_b37	17_64298682_G_A_b37	0.7719	SP1_HUMAN.H11MO.0.A	NA	21	22	positive	Heart_Left_Ventricle

32 PRKCA SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
31	PRKCA	ENSG00000154229	17_64315205_A_C_b37	17_64298682_G_A_b37	0.7719	SP1_HUMAN.H11MO.0.A	NA	16	22	negative	Heart_Left_Ventricle

33 RAB40B SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
32	RAB40B	ENSG00000141542	17_80645286_C_G_b37	17_80656616_T_G_b37	0.5906	SP1_HUMAN.H11MO.0.A	NA	22	22	negative	Heart_Left_Ventricle

34 RAB40B SP1_HUMAN.H11MO.1.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
33	RAB40B	ENSG00000141542	17_80645286_C_G_b37	17_80656616_T_G_b37	0.5906	SP1_HUMAN.H11MO.0.A	NA	12	22	negative	Heart_Left_Ventricle

35 RAB40B SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
34	RAB40B	ENSG00000141542	17_80645286_C_G_b37	17_80656616_T_G_b37	0.5906	SP1_HUMAN.H11MO.0.A	NA	17	22	negative	Heart_Left_Ventricle

36 RAB40B SP1_HUMAN.H11MO.1.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
35	RAB40B	ENSG00000141542	17_80645286_C_G_b37	17_80656616_T_G_b37	0.5906	SP1_HUMAN.H11MO.1.A	NA	12	14	negative	Heart_Left_Ventricle

37 SIPA1L3 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
36	SIPA1L3	ENSG00000105738	19_38670754_C_T_b37	19_38664097_C_T_b37	0.9999	SP1_HUMAN.H11MO.0.A	NA	14	22	negative	Heart_Left_Ventricle

38 SIPA1L3 SP1_HUMAN.H11MO.1.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
37	SIPA1L3	ENSG00000105738	19_38670754_C_T_b37	19_38664097_C_T_b37	0.9999	SP1_HUMAN.H11MO.0.A	NA	18	22	positive	Heart_Left_Ventricle

39 CCDC157 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
38	CCDC157	ENSG00000187860	22_30765502_G_A_b37	22_30752942_C_A_b37	0.9617	SP1_HUMAN.H11MO.0.A	NA	8	22	negative	Heart_Left_Ventricle

40 CCDC157 SP1_HUMAN.H11MO.1.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
39	CCDC157	ENSG00000187860	22_30765502_G_A_b37	22_30752942_C_A_b37	0.9617	SP1_HUMAN.H11MO.0.A	NA	2	22	negative	Heart_Left_Ventricle

41 TMA7 SP1_HUMAN.H11MO.1.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
40	TMA7	ENSG00000232112	3_48479207_C_T_b37	3_48481647_G_A_b37	0.9998	MA0079.3	SP1	11	11	negative	Heart_Left_Ventricle

42 PDIA2 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
41	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	MA0079.3	SP1	5	11	positive	Heart_Left_Ventricle

43 TMA7 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
42	TMA7	ENSG00000232112	3_48479207_C_T_b37	3_48481647_G_A_b37	0.9999	SP1_HUMAN.H11MO.1.A	NA	2	14	positive	Muscle_Skeletal

44 TMA7 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
43	TMA7	ENSG00000232112	3_48479207_C_T_b37	3_48481647_G_A_b37	0.9999	SP1_HUMAN.H11MO.0.A	NA	2	22	positive	Muscle_Skeletal

45 PDIA2 SP1_HUMAN.H11MO.1.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
44	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	SP1_HUMAN.H11MO.1.A	NA	8	14	negative	Muscle_Skeletal

46 PDIA2 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
45	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	SP1_HUMAN.H11MO.0.A	NA	8	22	negative	Muscle_Skeletal

47 PDIA2 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
46	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	SP1_HUMAN.H11MO.0.A	NA	15	22	negative	Muscle_Skeletal

48 PDIA2 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
47	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	SP1_HUMAN.H11MO.0.A	NA	2	22	negative	Muscle_Skeletal

49 PDIA2 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
48	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	SP1_HUMAN.H11MO.0.A	NA	17	22	negative	Muscle_Skeletal

50 PDIA2 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
49	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	SP1_HUMAN.H11MO.0.A	NA	13	22	negative	Muscle_Skeletal

51 PRKCA SP1_HUMAN.H11MO.1.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
50	PRKCA	ENSG00000154229	17_64315205_A_C_b37	17_64298682_G_A_b37	0.7876	SP1_HUMAN.H11MO.0.A	NA	21	22	positive	Muscle_Skeletal

52 PRKCA SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
51	PRKCA	ENSG00000154229	17_64315205_A_C_b37	17_64298682_G_A_b37	0.7876	SP1_HUMAN.H11MO.0.A	NA	16	22	negative	Muscle_Skeletal

53 RAB40B SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
52	RAB40B	ENSG00000141542	17_80645286_C_G_b37	17_80656616_T_G_b37	0.5207	SP1_HUMAN.H11MO.0.A	NA	22	22	negative	Muscle_Skeletal

54 RAB40B SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
53	RAB40B	ENSG00000141542	17_80645286_C_G_b37	17_80656616_T_G_b37	0.5207	SP1_HUMAN.H11MO.0.A	NA	12	22	negative	Muscle_Skeletal

55 RAB40B SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
54	RAB40B	ENSG00000141542	17_80645286_C_G_b37	17_80656616_T_G_b37	0.5207	SP1_HUMAN.H11MO.0.A	NA	17	22	negative	Muscle_Skeletal

56 RAB40B SP1_HUMAN.H11MO.1.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
55	RAB40B	ENSG00000141542	17_80645286_C_G_b37	17_80656616_T_G_b37	0.5207	SP1_HUMAN.H11MO.1.A	NA	12	14	negative	Muscle_Skeletal

57 SIPA1L3 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
56	SIPA1L3	ENSG00000105738	19_38670754_C_T_b37	19_38664097_C_T_b37	0.9995	SP1_HUMAN.H11MO.0.A	NA	14	22	negative	Muscle_Skeletal

58 SIPA1L3 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
57	SIPA1L3	ENSG00000105738	19_38670754_C_T_b37	19_38664097_C_T_b37	0.9995	SP1_HUMAN.H11MO.0.A	NA	18	22	positive	Muscle_Skeletal

59 CCDC157 SP1_HUMAN.H11MO.1.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
58	CCDC157	ENSG00000187860	22_30765502_G_A_b37	22_30752942_C_A_b37	0.9702	SP1_HUMAN.H11MO.0.A	NA	8	22	negative	Muscle_Skeletal

60 CCDC157 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
59	CCDC157	ENSG00000187860	22_30765502_G_A_b37	22_30752942_C_A_b37	0.9702	SP1_HUMAN.H11MO.0.A	NA	2	22	negative	Muscle_Skeletal

61 TMA7 SP1_HUMAN.H11MO.0.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
60	TMA7	ENSG00000232112	3_48479207_C_T_b37	3_48481647_G_A_b37	0.9999	MA0079.3	SP1	11	11	negative	Muscle_Skeletal

62 PDIA2 SP1_HUMAN.H11MO.1.A

	gene_name	ensembl_gene_id	leading_eqtl	motif_snp	r2	motif_id	motif_name	motif_snp.pos	motif.length	strand	tissue
61	PDIA2	ENSG00000185615	16_333146_C_T_b37	16_333146_C_T_b37	1	MA0079.3	SP1	5	11	positive	Muscle_Skeletal